﻿CREATE TABLE [dbo].[Category]
(
	[CategoryId] int identity NOT NULL,
	[Hidden] bit NOT NULL default 0,
	[ImageFullsizePath] nvarchar(200) NULL,
	[ImageThumbnailPath] nvarchar(200) NULL,
	[LongDescription] nvarchar(max) NULL,
	[Name] nvarchar(100) NOT NULL,
	[ParentCategoryId] int NULL,
	[SEOKeywords] nvarchar(1000) NULL,
	[SEOName] nvarchar(100) NOT NULL,
	[SEOTitle] nvarchar(100) NULL,
	[ShortDescription] nvarchar(1000) NULL,
	[SortOrder] int NOT NULL default 0	
);
